| |
1445 Search Results Found |
| 1 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 11:07 «»
By: nishant1987
Re: Sql behaving badly after upgrade
…HLA ,APPS.HZ_PARTIES
HPA ,APPS.HZ_CUST_ACCOUNTS HCA ,APPS.HZ_PARTY_SITES HPS
,APPS.HZ_LOCATIONS HLO ,APPS.HZ_CUST_ACCT_SITES HCS
,APPS.HZ_CUST_SITE_USES HCU ,APPS.HR_ALL_ORGANIZATION_UNITS HAO
,APPS.HR_ALL_ORGANIZATION_UNITS_TL HAT ,APPS.…
|
| 2 |
Forum: Server Utilities «»
Posted on: Tue, 24 May 2022 13:04 «»
By: Michel Cadot
Re: SQLLOADER
…CE(:CASH_BALANCE, ',', '')" ,
MONEY_ACCOUNTS CHAR "REPLACE(:MONEY_ACCOUNTS, ',', '')" ,
PRICED_INVESTMENTS CHAR "REPLACE(:PRICED_INVESTMENTS, ',', '')" ,
MARGIN_BALANCE CHAR "REPLACE(:MARGIN_BALANCE…
|
| 3 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 05 March 2023 23:05 «»
By: vinodkumarn
Need Help with Table Type
…PACKAGE SEG_PROCESS_PKG AS
PROCEDURE ins_accounts(SEG_REC IN SEG_ARRAY, STATUS_TYPE OUT VARCHAR2);
END SEG_PROCESS_PKG;
/
create or replace PACKAGE BODY SEG_PROCESS_PKG AS
PROCEDURE ins_accounts(SEG_REC IN SEG_ARRAY, STATUS_TYPE OUT VARCHAR2) IS
…
|
| 4 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 June 2023 11:30 «»
By: Michel Cadot
Re: Oracle function to get account balance
…
6 FROM CUSTOMER_ACCOUNTS CA
7 INNER JOIN customers c
8 ON ca.customer_id = c.customer_id
9 order by 1
10 …
|
| 5 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 08:14 «»
By: Nicha
check the integrity of a field between 3 or more tables - SQL Oracle
…is [ept01], referred to as table 1. All accounts, when created, must exist in this table as well as in the secondary tables "Table 2" with alias [ept02], and "Table 3" alias [ept03].
Below is a simplified representation of the 3 …
|
| 6 |
Forum: Server Utilities «»
Posted on: Fri, 21 October 2022 11:47 «»
By: Michel Cadot
Re: ...SQLLDR PROBLEM
… NUMBER (19,2),
9 MONEY_ACCOUNTS NUMBER (12,2),
10 PRICED_INVESTMENTS NUMBER (13,2),
11 MARGIN_BALANCE NUMBER (13,2),
12 MARKET_VALUE NUMBER (13,2)
13 )
14 /
…
|
| 7 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:55 «»
By: nishant1987
Re: Sql is causing performance issue
… TABLE ACCESS FULL | HZ_CUST_ACCOUNTS | 963K| 22M| | 13952 (1)| 00:00:01 |
|* 62 | ER HASH JOIN RIGHT OUT | | 130M| 9835M| 58M| 2490K…
|
| 8 |
Forum: Server Utilities «»
Posted on: Tue, 18 October 2022 01:38 «»
By: Littlefoot
Re: ...SQLLDR PROBLEM
… NUMBER (19,2),
9 MONEY_ACCOUNTS NUMBER (12,2),
10 PRICED_INVESTMENTS NUMBER (13,2),
11 MARGIN_BALANCE NUMBER (13,2),
12 MARKET_VALUE NUMBER (13,2)
…
|
| 9 |
Forum: Server Utilities «»
Posted on: Mon, 23 May 2022 15:19 «»
By: Wideminnow6970
SQLLOADER
… NUMBER(11,2)
MONEY_ACCOUNTS NUMBER(11,2)
PRICED_INVESTMENTS NUMBER(11,2)
MARGIN_BALANCE NUMBER(11,2)
MARKET_VALUE…
|
| 10 |
Forum: Community Hangout «»
Posted on: Tue, 21 May 2024 07:17 «»
By: Barbara Boehmer
Re: MICROWAVE WOES
…can do about being locked out of two email accounts. I have used my homtmail email account for most things for years. Every now and then it requests some additional verification and it did that this time, sending the verification code to my …
|
| 11 |
Forum: Security «»
Posted on: Thu, 07 March 2024 05:55 «»
By: Darth Waiter
Re: Max string size for regular users
…software has to run under arbitrary user accounts chosen by the end user. More often than not they would choose regular user accounts nor would they even be aware of such things. I have no control of what they do or do not.
I find to be very odd Oracle…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 07:54 «»
By: Barbara Boehmer
Re: Ranking account and customer balances
…nbsp; i_account_number IS NULL; -- all accounts
16 RETURN v_balance;
17 END;
18 prep as (
19 SELECT C.CUSTOMER_ID,
20 C.FIRST_NAME,
21 C.LAST_NAME…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 June 2023 10:44 «»
By: Unclefool
Re: Oracle function to get account balance
…p; -- all accounts
RETURN v_balance;
END;
/
SELECT CA.ACCOUNT_NUMBER,
C.FIRST_NAME,
C.LAST_NAME,
…
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 June 2023 05:45 «»
By: Unclefool
Oracle function to get account balance
…have customers, which have multiple accounts. For each account I keep a separate balance.
As you can see below I can produce a detailed daily summary of each account. What would be the best way to wrap this detail into a function, which returns only …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 March 2023 01:05 «»
By: Michel Cadot
Re: Need Help with Table Type
From your previous topic:
...
Error at "ins_accounts(seg_arr,status);"
Compare:
ins_accounts(SEG_REC IN SEG_ARRAY...
seg_arr varchar(100)
So "wrong number or types of arguments in call to 'INS_ACCOUNTS'"
|
| 16 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 11:05 «»
By: nishant1987
Re: Sql behaving badly after upgrade
… HPA,
APPS.HZ_CUST_ACCOUNTS HCA,
APPS.HZ_PARTY_SITES HPS,
APPS.HZ_LOCATIONS HLO,
APPS.HZ_CUST_ACCT_SITES HCS,
APPS.HZ_CUST_SITE_USES…
|
| 17 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:54 «»
By: nishant1987
Sql behaving badly after upgrade
… HPA,
APPS.HZ_CUST_ACCOUNTS HCA,
APPS.HZ_PARTY_SITES HPS,
APPS.HZ_LOCATIONS HLO,
APPS.HZ_CUST_ACCT_SITES HCS,
APPS.HZ_CUST_SITE_USES…
|
| 18 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:51 «»
By: nishant1987
Re: Sql is causing performance issue
… HPA,
APPS.HZ_CUST_ACCOUNTS HCA,
APPS.HZ_PARTY_SITES HPS,
APPS.HZ_LOCATIONS HLO,
APPS.HZ_CUST_ACCT_SITES HCS,
APPS.HZ_CUST_SITE_USES…
|
| 19 |
Forum: Performance Tuning «»
Posted on: Tue, 18 October 2022 10:48 «»
By: nishant1987
Sql behaving badly after upgrade (merged)
… HPA,
APPS.HZ_CUST_ACCOUNTS HCA,
APPS.HZ_PARTY_SITES HPS,
APPS.HZ_LOCATIONS HLO,
APPS.HZ_CUST_ACCT_SITES HCS,
APPS.HZ_CUST_SITE_USES…
|
| 20 |
Forum: Forms «»
Posted on: Fri, 23 September 2022 04:14 «»
By: rhnshk
fetch resutl of a query in a variable
…mprd_amount,'999999,990')
FROM MPR_FORMD,ACCOUNTS_MASTER
WHERE ACNT_CODE = MPRD_ITEM_CODE
AND MPRDH_NO = 384;
VAL VARCHAR2(4000);
ed_ok BOOLEAN;
BEGIN
OPEN C_TXT1;
FETCH C_TXT1 INTO VAL;
CLOSE C_TXT1…
|
| 21 |
Forum: Security «»
Posted on: Thu, 07 March 2024 10:18 «»
By: Darth Waiter
Re: Max string size for regular users
…that I do not own, under arbitrary user accounts.
The only way is to try to create a table with a single column that is longer than 2000 characters and trap error 910, which violates one of the fundamental principles of software development: do not use …
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 16 August 2023 09:06 «»
By: Solomon Yakobson
Re: check the integrity of a field between 3 or more tables - SQL Oracle
…'
end missing_accounts
from t
group by account_id
having sum(tbl_flag) != 7
/
SY.
P.S. change sum(tbl_flag) to sum(distinct tbl_flag) if account_id isn't unique within tables…
|
| 23 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 15 August 2023 15:46 «»
By: mathguy
Re: Ranking account and customer balances
…p; -- all accounts
RETURN v_balance;
END;
prep as (
SELECT C.CUSTOMER_ID,
C.FIRST_NAME,
C.LAST_NAME,
…
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 15 August 2023 15:19 «»
By: Unclefool
Re: Ranking account and customer balances
…way I will have 2 pieces of code, one for accounts and the other for customers. I attempted this myself but was running in syntax error after error.
My main concern is just to get the syntax correct!! For the sake of this conversation let's say I want …
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 15 August 2023 13:35 «»
By: mathguy
Re: Ranking account and customer balances
…balances? Customer balances? Top two accounts for each customer? Something else?
Also, you said you are using DENSE_RANK to get the ties. That is very rarely the correct function to use. If there are three "records" tied for highest balance, …
|
| 26 |
Forum: Server Administration «»
Posted on: Mon, 24 April 2023 15:21 «»
By: Michel Cadot
Re: disconnect the schema
... and some controls to prevent from locking some important accounts and killing important sessions.
And maybe some outputs...
|
| 27 |
Forum: Marketplace «»
Posted on: Mon, 03 April 2023 00:05 «»
By: Alexeyg
Meet dbForge Edge - Brand New Multidatabase Solution by Devart
… Database administration: Management of user accounts with privileges and permissions, server session management, events tracking, table maintenance, and index defragmentation.
To learn more about the recent release, refer to
https://blog.devart…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 30 September 2022 09:08 «»
By: nishant1987
ANSI JOIN requirement
… (SELECT CONCATENATED_SEGMENTS AS charge_accountsfrom
FROM apps.gl_code_combinations_kfv gcc
WHERE gcc.code_combination_id = pdi.code_combination_id)
AS charge_accounts
FROM apps.po_headers_all pha,
…
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 27 September 2022 23:52 «»
By: nishant1987
Sql is causing performance issue
… (SELECT CONCATENATED_SEGMENTS AS charge_accountsfrom
FROM apps.gl_code_combinations_kfv gcc
WHERE gcc.code_combination_id = pdi.code_combination_id)
AS charge_accounts
FROM apps.po_headers_all pha,
…
|
| 30 |
Forum: Forms «»
Posted on: Sat, 24 September 2022 04:56 «»
By: rhnshk
Re: fetch resutl of a query in a variable
…9999,990'),1,15) val
3 FROM MPR_FORMD,ACCOUNTS_MASTER
4 WHERE ACNT_CODE = MPRD_ITEM_CODE
5* AND MPRDH_NO = 384
SQL> /
VAL
-------------------------------------------
384 R&M DOOR ACCESS CONT 143
384 R&…
|
| 31 |
Forum: Forms «»
Posted on: Sat, 24 September 2022 03:55 «»
By: Littlefoot
Re: fetch resutl of a query in a variable
…mount,'999999,990') val
FROM MPR_FORMD,ACCOUNTS_MASTER
WHERE ACNT_CODE = MPRD_ITEM_CODE
AND MPRDH_NO = 384
)
loop
val := val || chr(10) || cur_r.val;
end loop;
Show_Editor( 'REMARKS_EDIT', val, 250,150, val…
|
| 32 |
Forum: Suggestions & Feedback «»
Posted on: Sun, 12 June 2022 06:13 «»
By: Michel Cadot
Re: Who is Solomon?
Also the 2 posts before the last one were posted by the 2 accounts and the same IP within 6 minutes.
In a PM, Solomon told me his screen was showing "Logout [kkaschke]"!
|
| 33 |
Forum: Server Utilities «»
Posted on: Tue, 24 May 2022 11:48 «»
By: Mahesh Rajendran
Re: SQLLOADER
…CHAR ,
ACCOUNT_NUMBER_OLD CHAR ,
ACCOUNT_NAME CHAR ,
ACCOUNT_REGISTRATION CHAR ,
CASH_BALANCE CHAR ,
MONEY_ACCOUNTS CHAR ,
PRICED_INVESTMENTS CHAR ,
MARGIN_BALANCE CHAR ,
MARKET_VALUE CHAR…
|
| 34 |
Forum: Marketplace «»
Posted on: Wed, 17 August 2016 09:46 «»
By: Michel Cadot
McDP: like expdp/impdp Data Pump programs and much more
…p; Gets the DDL to recreate accounts with, possibly, roles, system grants and
object grants.
{ -val | --validate } {<directory>:<file>|<full path file>…
|
| 35 |
Forum: Backup & Recovery «»
Posted on: Wed, 06 October 2021 06:05 «»
By: John Watson
Re: User managed backup fails with OSD-04002
….
You may well be hitting issues caused by Windows security. Are the services running under local accounts or domain accounts? Are the files owned by a local or a domain user? Is this drive D: a local device or something exported from a remote machine…
|
| 36 |
Forum: Windows «»
Posted on: Fri, 25 June 2021 03:06 «»
By: John Watson
Re: Oracle VSS Services
Received as a private message:
I think this is saying that my suggestion was correct: the problem was incorrect use of Windows accounts.
|
| 37 |
Forum: Windows «»
Posted on: Wed, 23 June 2021 11:05 «»
By: John Watson
Re: Oracle VSS Services
…frequently there are issues with the Windows accounts under which the various services are running. Is your VSS service running under the same account as the DB service? What account is running the Acronis service? Are you using local or domain accounts…
|
| 38 |
Forum: Oracle Fusion Apps & E-Business Suite «»
Posted on: Thu, 13 May 2021 21:22 «»
By: hh06
Set up non-financial data in Oracle GL (EBS & Fusion)
…and/or Fusion), link to a data warehouse (ex. Oracle Hyperion), and end with an output solution (ex. data reporting tool)?
So in the case of whenever you need to create new accounts, you begin with Oracle GL.
Appreciate y'all comments and insights…
|
| 39 |
Forum: Server Administration «»
Posted on: Wed, 10 March 2021 14:28 «»
By: Michel Cadot
Re: Restrict email recipients
…e) and then grant EXECUTE privilege to other accounts on this procedure.
So instead of calling:
UTL_MAIL.SEND (sender=>..., recipients=>..., subject=>..., message=>...);
you will call
My_Send (sender=>..., recipients=>..., subject…
|
| 40 |
Forum: Server Utilities «»
Posted on: Wed, 17 February 2021 12:51 «»
By: Michel Cadot
Re: impdp bypassing DUMPFILE
…or outside the server or a specific network...).
You can easily use Oracle scheduler to plan your schema copy.
You can then allow some accounts to do the copy without giving them DATAPUMP_EXP_FULL_DATABASE or DATAPUMP_IMP_FULL_DATABASE role…
|
Blog
Search
Help
Members
Register
Login
Home